USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_CURRICULO_REDE_SOCIAL_ALTERAR')
	DROP PROCEDURE P_CURRICULO_REDE_SOCIAL_ALTERAR
GO
CREATE PROCEDURE P_CURRICULO_REDE_SOCIAL_ALTERAR(
	@IDREDESOCIAL	INTEGER,
	@IDCURRICULO	INTEGER,
	@LINKREDESOCIAL	VARCHAR(100))
AS BEGIN
	UPDATE
		CURRICULO_REDE_SOCIAL
	SET
		LINKREDESOCIAL = @LINKREDESOCIAL,
		DTHRALTERACAO = GETDATE()
	WHERE
		IDCURRICULO = @IDCURRICULO
		AND IDREDESOCIAL = @IDREDESOCIAL
END